Overview

Dataset Statistics

Number of Variables 6
Number of Rows 37399
Missing Cells 0
Missing Cells (%) 0.0%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 1.7 MB
Average Row Size in Memory 48.0 B
Variable Types
  • Numerical: 2
  • Categorical: 1
  • DateTime: 3

Dataset Insights

DL has constant length 1 Constant Length

Variables


IDX

numerical

Approximate Distinct Count 37399
Approximate Unique (%) 100.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 584.4 KB
Mean 39313.9806
Minimum 1
Maximum 85219
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • IDX is skewed left (γ1 = -0.0152)

Quantile Statistics

Minimum 1
5-th Percentile 1870.9
Q1 12340.5
Median 43600
Q3 60719.5
95-th Percentile 83349.1
Maximum 85219
Range 85218
IQR 48379

Descriptive Statistics

Mean 39313.9806
Standard Deviation 26845.5092
Variance 7.2068e+08
Sum 1.4703e+09
Skewness -0.01517
Kurtosis -1.367
Coefficient of Variation 0.6828
  • IDX is not normally distributed (p-value 5.481117270187319e-14)

DL

categorical

Approximate Distinct Count 5
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 2.4 MB

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 1
2nd row 2
3rd row 3
4th row 4
5th row 5

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 37399
  • DL has words of constant length

INPUT_START_DT

datetime

Distinct Count 6717.8407
Approximate Unique (%) 18.0%
Missing 0
Missing (%) 0.0%
Memory Size 292.3 KB
Minimum 2020-02-28 14:00:00
Maximum 2021-01-05 04:00:00

INPUT_END_DT

datetime

Distinct Count 6712.3012
Approximate Unique (%) 17.9%
Missing 0
Missing (%) 0.0%
Memory Size 292.3 KB
Minimum 2020-02-29 01:00:00
Maximum 2021-01-05 15:00:00

DT

datetime

Distinct Count 7499.1483
Approximate Unique (%) 20.1%
Missing 0
Missing (%) 0.0%
Memory Size 292.3 KB
Minimum 2020-03-01 01:00:00
Maximum 2021-01-06 16:00:00

PRED_ELEC

numerical

Approximate Distinct Count 33791
Approximate Unique (%) 90.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 584.4 KB
Mean 1282.5239
Minimum 0
Maximum 3941.4529
Zeros 1
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • PRED_ELEC is skewed right (γ1 = 0.8188)

Quantile Statistics

Minimum 0
5-th Percentile 458.176
Q1 796.9704
Median 1219.8586
Q3 1641.0691
95-th Percentile 2371.1218
Maximum 3941.4529
Range 3941.4529
IQR 844.0987

Descriptive Statistics

Mean 1282.5239
Standard Deviation 609.4519
Variance 371431.6161
Sum 4.7965e+07
Skewness 0.8188
Kurtosis 0.7878
Coefficient of Variation 0.4752
  • PRED_ELEC is not normally distributed (p-value 9.088159939935733e-06)
  • PRED_ELEC has 578 outliers

Interactions

Correlations

Missing Values